package com.ams.mapper;

import com.ams.entity.Order;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author liuxiaoding
 * @data 2019/7/5
 */
@Mapper
public interface OrderMapper {
    @Select("select openid,pv_total pvTotal from ims_ewei_shop_order where order_type=1 and `status` in(1,2,3) and openid in(select child_openid from ims_qu_log where pid=#{pid} and type=#{quType} and count=#{count}) order by pv_total asc,paytime ASC")
    Order getZcD(Integer pid,Integer quType,Integer count);
}
